Required permissions
The user specified in the General tab when Setting general connection properties must be granted the following permissions in the AWS Aurora Cloud for PostgreSQL database:
- For Full Load replication: Standard SELECT on the source database
- For Apply Changes replication: See Setting up AWS Aurora Cloud for PostgreSQL for CDC (Change data capture).
-
When the Apply Changes and/or Store Changes task replication option is enabled, the user specified in the AWS Aurora Cloud for PostgreSQL source endpoint’s General tab must be granted superuser permissions.